One moment please...
 

Exact Generation XL - Financials version 3.50 is available see document 14.502.918 for the IFALL files for version 3.50.

The attached zip file contains the files required for (re)compiling your IFALL link for Exact Generation XL - Financials version 3.42.

Change register

versionentitychangerecompile required
3.30 journal entries
creditors
debtors
exchange rates
IFALL1 no longer supported yes - also need to rewrite interface to use IFALL4 (or IFALL3)
3.30 company data new -
3.30 multi dimensions upgraded from IFALL3 to IFALL4 yes
3.30 project hour entries upgraded from IFALL3 to IFALL4 yes
3.30 project item entries upgraded from IFALL2 to IFALL4 yes
3.30 project direct entries upgraded from IFALL2 to IFALL4 yes
3.30 exchange rates upgraded from IFALL1 to IFALL4 yes
3.31 all IFALL4 ASSIGN function no longer uses tmp-table-original records no
3.31 project employees upgraded from IFALL3 to IFALL4 yes
3.31 project positions new -
3.31 project states new -
3.31 project types new -
3.31 fixed assets new -
3.31 link cost center / g/l accounts new -
3.31 link cost unit / g/l accounts new -
3.32 debtors
creditors
project master cards
g/l accounts
assets
notes fields can be 16,000 characters instead of 2,000 no
3.33g/l links new -
3.34 journal entries new IFALL4 , IFALL2 and IFALL3 are linked through to IFALL4 no
3.40 - temp-table table handles can be used for passing data to prevent recompile when extra fields added to temp-table yes
3.40project locations  new -
3.40postal codes  new -
3.40ISO countries / ISO currencies / ISO languages  new -
3.40g/l accounts temp-table field names standardized yes - also need to adjust interface
3.40shared variables shared variables (a.o. s-adm-nr for company number) are no longer used, used system/inc/session.i instead yes
3.41asset locations / asset departments / asset groups / asset sets new -
3.41collection arrangements upgraded from IFALL3 to IFALL4 yes
3.42 hour categories / surcharge codes / project machinery / project units / asset books / index tables / commitment classifications / commitment / contracts new -
3.42 project master cards parent project added yes *
3.42 commitments immediate processing added yes *
3.42 journals bank statement data added yes *
3.42 cost centers cost center manager added yes *

* Only when not using the dynamic interface available as of 3.40 - see document 12.354.256 for details. 

Note

We recommend using the newer IFALL modules as the newer IFALL versions support more functionality. Also, the older IFALL modules are generally linked through to the newer IFALL module resulting in unncessary overhead. For example ifdebtor.p simply passes its data to ifdebtor4.p. The results are then passed back from ifdebtor4.p to ifdebtor.p.

Examples

Example programs are available in the examples directory in the zip file:

Journal entries (IFALL4):

  • BankJournalEntry.p
  • CashJournalEntry.p
  • GeneralJournalEntry.p
  • GiroJournalEntry.p
  • PurchaseJournalEntry.p
  • SalesJournalEntry.p 

Various (IFALL4):

  • CorsaAppServer.p (demonstrates using dynamic IFALL interface and AppServer connection)
  • Creditors.p (create)
  • CreditorsSearch.p (find)
  • Debtors.p
  • DeleteDebtor.p
  • IncomingInvoices.p
  • MachineryEntries.p
  • OutstandingItemTotal.p (demonstrates IFALL search to get total outstanding amount)
  • ProjectMasterCards.p
  • SubClassifications
  • VATcodes.p

Overview IFALLs

Finance

Master data
tabledescriptionIFALL file nametemp-table file nameIFALL version
admdat / admnac company data / company addresses finance/interf/ifadmdat.p finance/interf/inc/ifadmdat.i 4
bnktpebank account typesfinance/interf/ifbnktpe.pfinance/interf/inc/ifbnktpe.i4
ccentcost centers finance/interf/ifccent.pfinance/interf/inc/ifccent.i4
colarrcollection arrangements finance/interf/ifcolarr.pfinance/interf/inc/ifcolarr.i4
comcls commitment classifications finance/interf/ifcomcls.p finance/interf/inc/ifcomcls.i 4
comctr commitment contracts finance/interf/ifcomctr.p finance/interf/inc/ifcomctr.i 4
compsub-classificationsfinance/interf/ifcomp.pfinance/interf/inc/ifcomp.i4
countrcountriesfinance/interf/ifcountr.pfinance/interf/inc/ifcountr.i4
crdbnkcreditor bank accountsfinance/interf/ifcrdbnk.pfinance/interf/inc/ifcrdbnk.i3 (replaced by ifcredit4)
crdcatcreditor categories finance/interf/ifcrdcat.pfinance/interf/inc/ifcrdcat.i 4
creditcreditorsfinance/interf/ifcredit.pfinance/interf/inc/ifcredit.i3 (replaced by ifcredit4)
credit / bnklnk / bnkacc / crdnaccreditorsfinance/interf/ifcredit4.pfinance/interf/inc/ifcredit4.i4
cunitcost units finance/interf/ifcunit.pfinance/interf/inc/ifcunit.i4
currencurrenciesfinance/interf/ifcurren.pfinance/interf/inc/ifcurren.i4
debbnkdebtor bank accountsfinance/interf/ifdebbnk.pfinance/interf/inc/ifdebbnk.i3 (replaced by ifdebtor4)
debcatdebtor categories finance/interf/ifdebcat.pfinance/interf/inc/ifdebcat.i 4
debtordebtorsfinance/interf/ifdebtor.pfinance/interf/inc/ifdebtor.i3 (replaced by ifdebtor4)
debtor / bnklnk / bnkacc / delnac / prdebdebtorsfinance/interf/ifdebtor4.pfinance/interf/inc/ifdebtor4.i4
iiowninvoice owners finance/interf/ifiiown.pfinance/interf/inc/ifiiown.i4
journljournalsfinance/interf/ifjournl.pfinance/interf/inc/ifjournl.i4
langlanguagesfinance/interf/iflang.pfinance/interf/inc/iflang.i4
ledgergeneral ledger acounts finance/interf/ifledger.pfinance/interf/inc/ifledger.i4
mcompmain classifications finance/interf/ifmcomp.pfinance/interf/inc/ifmcomp.i4
mdim1multi-dimension 1 finance/interf/ifmdim1.pfinance/interf/inc/ifmdim1.i
mdim2multi-dimension 2 finance/interf/ifmdim2.pfinance/interf/inc/ifmdim2.i
mdim3multi-dimension 3 finance/interf/ifmdim3.pfinance/interf/inc/ifmdim3.i
mdim4multi-dimension 4 finance/interf/ifmdim4.pfinance/interf/inc/ifmdim4.i
mdim5multi-dimension 5 finance/interf/ifmdim5.pfinance/interf/inc/ifmdim5.i
payconpayment conditions finance/interf/ifpaycon.pfinance/interf/inc/ifpaycon.i4
props / prpmc cost center properties finance/interf/ifprops-ccent.p finance/interf/inc/ifprops-ccent.i 4
props / prpmc creditor properties finance/interf/ifprops-credit.p finance/interf/inc/ifprops-credit.i 4
props / prpmc cost unit properties finance/interf/ifprops-cunit.p finance/interf/inc/ifprops-cunit.i 4
props / prpmc debtor properties finance/interf/ifprops-debtor.p finance/interf/inc/ifprops-debtor.i 4
props / prpmc asset properties finance/interf/ifprops-fas_ast.p finance/interf/inc/ifprops-fas_ast.i 4
props / prpmc g/l account properties finance/interf/ifprops-ledger.p finance/interf/inc/ifprops-ledger.i 4
settg/l linksfinance/interf/ifgllink.pfinance/interf/inc/ifgllink.i4
titlestitlesfinance/interf/iftitles.pfinance/interf/inc/iftitles.i4
vattrsVAT codes finance/interf/ifvattrs.pfinance/interf/inc/ifvattrs.i4

Entries
tabledescriptionIFALL file nametemp-table file name IFALL version
atrsh / atrssjournal entriesfinance/interf/ifatrs.pfinance/interf/ifatrs.i2.5 (replaced by ifatrs-*)
atrsh / atrssjournal entriesfinance/interf/iffife.pfinance/interf/inc/iffife.i3 (replaced by ifatrs-*)
atrsh / atrssaccrual journal entriesfinance/interf/ifatrs-accrual.pfinance/interf/inc/ifatrs-accrual.i4
atrsh / atrss bank journal entries finance/interf/ifatrs-bank.p finance/interf/inc/ifatrs-bank.i 4
atrsh / atrss cash journal entries finance/interf/ifatrs-cash.p finance/interf/inc/ifatrs-cash.i 4
atrsh / atrss general journal entries finance/interf/ifatrs-general.p finance/interf/inc/ifatrs-general.i 4
atrsh / atrss giro journal entries finance/interf/ifatrs-giro.p finance/interf/inc/ifatrs-giro.i 4
atrsh / atrss purchase journal entries finance/interf/ifatrs-purchase.p finance/interf/inc/ifatrs-purchase.i 4
atrsh / atrss sales journal entries finance/interf/ifatrs-sales.p finance/interf/inc/ifatrs-sales.i 4
atrsh / atrss VAT journal entries finance/interf/ifatrs-vat.p finance/interf/inc/ifatrs-vat.i 4
crdoutcreditor outstanding items finance/interf/ifcrdout.pfinance/interf/inc/ifcrdout.i4
comhl / comsl / comelcommitmentsfinance/interf/ifcom.pfinance/interf/inc/ifcom.i4
deboutdebtor outstanding items finance/interf/ifdebout.pfinance/interf/inc/ifdebout.i4
fireh / firelrecurring entries finance/interf/iffire.pfinance/interf/inc/iffire.i3
iiregincoming invoice registration finance/interf/ifiireg.pfinance/interf/inc/ifiireg.i4
xratesexchange rates finance/interf/ifxrates.pfinance/interf/inc/ifxrates.i 4

Logistic

Master data
tabledescriptionIFALL file nametemp-table file name IFALL version
llcoccost codeslogistic/interf/ifllcoc.plogistic/interf/inc/ifllcoc.i4
lldescextra description codeslogistic/interf/iflldesc.plogistic/interf/inc/iflldesc.i 4
lldomedelivery / order methodslogistic/interf/iflldome.plogistic/interf/inc/iflldome.i 4
lligrpitem groupslogistic/interf/iflligrp.plogistic/interf/inc/iflligrp.i4
llinvcinvoice codes logistic/interf/ifllinvc.plogistic/interf/inc/ifllinvc.i 4
llitemitemslogistic/interf/ifllitem.plogistic/interf/inc/ifllitem.i 4
llpligprice lists per item group logistic/interf/ifllplig.plogistic/interf/inc/ifllplig.i 4
llplitprice lists per item logistic/interf/ifllplit.plogistic/interf/inc/ifllplit.i 4
llplstprice listslogistic/interf/ifllplst.plogistic/interf/inc/ifllplst.i4
lltextgeneral text codeslogistic/interf/iflltext.plogistic/interf/inc/iflltext.i3
lsreprepresentativeslogistic/interf/iflsrep.plogistic/interf/inc/iflsrep.i 4
props / prpmc item properties finance/interf/ifprops-llitem.p finance/interf/inc/ifprops-llitem.i 4

Entries
tabledescriptionIFALL file nametemp-table file name IFALL version
lsihl / lsislsales invoiceslogistic/interf/iflsei.plogistic/interf/inc/iflsei.i 4
lsohl / lsoslsales orders logistic/interf/iflseo.plogistic/interf/inc/iflseo.i4
lpeih / lpeilpurchase invoices logistic/interf/iflpei.plogistic/interf/inc/iflpei.i 4
lpeoh / lpeolpurchase orders logistic/interf/iflpeo.plogistic/interf/inc/iflpeo.i4
lperh / lperlreceiptslogistic/interf/iflper.plogistic/interf/inc/iflper.i 4

Project

Master data
tabledescriptionIFALL file nametemp-table file name IFALL version
prccatcost categories project/interf/ifprccat.pproject/interf/inc/ifprccat.i4
prdepdepartmentsproject/interf/ifprdep.pproject/interf/inc/ifprdep.i 4
prempemployeesproject/interf/ifpremp.pproject/interf/inc/ifpremp.i4
prhcat hour categories project/interf/ifprhcat.p project/interf/inc/ifprhcat.i 4
pringhproject invoice groups project/interf/ifpringh.pproject/interf/inc/ifpringh.i4
prgrpproject groups project/interf/ifprgrp.pproject/interf/inc/ifprgrp.i4
prlocproject locationsproject/interf/ifprloc.pproject/interf/inc/ifprloc.i4
prmst / prmstdebproject master cards project/interf/ifprmst.pproject/interf/inc/ifprmst.i4
props / prpmc employee properties finance/interf/ifprops-premp.p finance/interf/inc/ifprops-premp.i 4
props / prpmc machinery properties finance/interf/ifprops-prmach.p finance/interf/inc/ifprops-prmach.i 4
props / prpmc project master card properties finance/interf/ifprops-prmst.p finance/interf/inc/ifprops-prmst.i 4
prpos project position project/interf/ifprpos.p project/interf/inc/ifprpos.i 4
prstat project state project/interf/ifprstat.p project/interf/inc/ifprstat.i 4
prsurc surcharge codes project/interf/ifprsurc.p project/interf/inc/ifprsurc.i 4
prtype project state project/interf/ifprtype.p project/interf/inc/ifprtype.i 4
prunit project units project/interf/ifprunit.p project/interf/inc/ifprunit.i 4

Entries
tabledescriptionIFALL file nametemp-table file nameIFALL version
prdeh / prdesproject direct entriesproject/interf/ifprde.pproject/interf/inc/ifprde.i 4
prieh / priesproject item entriesproject/interf/ifprie.pproject/interf/inc/ifprie.i 4
prheh / prhesproject hour entriesproject/interf/ifprhe.pproject/interf/inc/ifprhe.i 4
prinsh / prinssproject installments project/interf/ifprins.pproject/interf/inc/ifprins.i 4
prmeh / prmesproject machinery entries project/interf/ifprme.pproject/interf/inc/ifprme.i4
prrccaproject budget per cost category project/interf/ifprrcca.pproject/interf/inc/ifprrcca.i4
prrcypproject budget per cost category per period project/interf/ifprrcyp.pproject/interf/inc/ifprrcyp.i4
prrhcaproject budget per hour category project/interf/ifprrhca.pproject/interf/inc/ifprrhca.i4
prrhypproject budget per hour category per periodproject/interf/ifprrhyp.pproject/interf/inc/ifprrhyp.i4
prritmproject budget per item project/interf/ifprritm.pproject/interf/inc/ifprritm.i4
prriypproject budget per item per periodproject/interf/ifprriyp.pproject/interf/inc/ifprriyp.i4
prrmchproject budget per machinery project/interf/ifprrmch.pproject/interf/inc/ifprrmch.i4
prrmypproject budget per machinery per periodproject/interf/ifprrmyp.pproject/interf/inc/ifprrmyp.i4

Fixed Assets

Master data
tabledescriptionIFALL file nametemp-table file nameIFALL version
dpr_idxm / dpr_idxd index tables assets/interf/ifdpr_idxm.p assets/interf/ifdpr_idxm.i 4
fas_ast / fas_depr / fas_prmstfixed assets assets/interf/iffas_ast.passets/interf/inc/iffas_ast.i4
fas_book asset books assets/interf/iffas_book.p assets/interf/inc/iffas_book.i 4
fas_loclocationsassets/interf/iffas_loc.passets/interf/iffas_loc.i4
fas_deptdepartmentsassets/interf/iffas_dept.passets/interf/iffas_dept.i4
fas_grpasset groupsassets/interf/iffas_grp.passets/interf/iffas_grp.i4
fas_mastasset setsassets/interf/iffas_mast.passets/interf/iffas_mast.i4

System

Master data
tabledescriptionIFALL file nametemp-table file nameIFALL version
isocntISO countries finance/interf/ifisocnt.pfinance/interf/inc/ifisocnt.i4
isocurISO currencies finance/interf/ifisocur.pfinance/interf/inc/ifisocur.i4
isolngISO languages finance/interf/ifisolng.pfinance/interf/inc/ifisolng.i4
stexcaexternal categoriessystem/interf/ifstexca.p
system/interf/ifstexca0.p
system/interf/inc/ifstexca.i
system/interf/inc/ifstexca0.i
4

Entries 
tabledescriptionIFALL file nametemp-table file name IFALL version
prpvalpropertiessystem/interf/ifprpval.psystem/interf/inc/ifprpval.i
stexobexternal objectssystem/interf/ifstexob.psystem/interf/inc/ifstexob.i4


Attachments
ifall342.zip 595.4 KB Download